package com.alks.entity.data.entity.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

import java.util.Date;

/**
 * @author:hxl
 * @create: 2024-04-05 19:51
 * @Description: 业务材料表
 */
@Getter
@Setter
@NoArgsConstructor
@HeadStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER,verticalAlignment = VerticalAlignmentEnum.CENTER)
@HeadFontStyle(fontHeightInPoints = 16)
@HeadRowHeight(20)
public class BusMtlDataSheet {
    @ColumnWidth(40)
    @ExcelProperty({"业务材料资料表", "大类"})
    private String typeName1;
    @ColumnWidth(30)
    @ExcelProperty({"业务材料资料表","中类"})
    private String typeName2;
    @ColumnWidth(40)
    @ExcelProperty({"业务材料资料表","物料编码"})
    private String mtlNo;
    @ColumnWidth(30)
    @ExcelProperty({"业务材料资料表","颜色"})
    private String mtlColor;
    @ColumnWidth(30)
    @ExcelProperty({"业务材料资料表","物料名称"})
    private String mtlName;
    @ExcelProperty({"业务材料资料表","单位"})
    private String mtlUnit;
    @ExcelProperty({"业务材料资料表","规格"})
    private String mtlSpec;
    @ColumnWidth(18)
    @ExcelProperty({"业务材料资料表","建档人员"})
    private String sysUser;
    @ExcelProperty({"业务材料资料表","建档日期"})
    @DateTimeFormat(value = "yyyy/mm/dd")
    @JsonFormat(pattern = "yyyy/mm/dd")
    @ColumnWidth(18)
    private Date sysDate;
    @ExcelProperty({"业务材料资料表","厂商"})
    private String vendor;
    @ColumnWidth(30)
    @ExcelProperty({"业务材料资料表","备注"})
    private String remark;

}
